package com.itheima.health.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.health.pojo.OrderSetting;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface OrderSettinglMapper extends BaseMapper<OrderSetting> {

   @Select("select ORDERDATE, NUMBER,RESERVATIONS\n" +
           "from t_ordersetting\n" +
           "where  ORDERDATE between #{beginDate} and #{endDarte} ")
    List<OrderSetting> findSettingDateByYearAndMonth(@Param("beginDate") String beginDate,@Param("endDarte") String endDarte);

}
